Pandas Profiling Report

Dataset statistics

Number of variables	24
Number of observations	3325
Missing cells	962
Missing cells (%)	1.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	532.6 KiB
Average record size in memory	164.0 B

Variable types

Categorical	4
Text	3
Numeric	13
Boolean	4

Alerts

`compliancestatus` has constant value ""	Constant
`councildistrictcode` is highly overall correlated with `latitude` and 1 other fields	High correlation
`propertygfatotal` is highly overall correlated with `propertygfabuilding_s` and 2 other fields	High correlation
`propertygfabuilding_s` is highly overall correlated with `propertygfatotal` and 2 other fields	High correlation
`largestpropertyusetypegfa` is highly overall correlated with `propertygfatotal` and 2 other fields	High correlation
`energystarscore` is highly overall correlated with `electricity`	High correlation
`totalghgemissions` is highly overall correlated with `propertygfatotal` and 2 other fields	High correlation
`latitude` is highly overall correlated with `councildistrictcode` and 1 other fields	High correlation
`buildingtype` is highly overall correlated with `primarypropertytype` and 1 other fields	High correlation
`primarypropertytype` is highly overall correlated with `buildingtype` and 1 other fields	High correlation
`neighborhood` is highly overall correlated with `councildistrictcode` and 1 other fields	High correlation
`electricity` is highly overall correlated with `energystarscore`	High correlation
`defaultdata` is highly overall correlated with `buildingtype` and 1 other fields	High correlation
`steamuse` is highly imbalanced (76.3%)	Imbalance
`electricity` is highly imbalanced (98.4%)	Imbalance
`defaultdata` is highly imbalanced (79.0%)	Imbalance
`energystarscore` has 819 (24.6%) missing values	Missing
`compliancestatus` has 121 (3.6%) missing values	Missing
`numberofbuildings` is highly skewed (γ1 = 43.65087907)	Skewed
`propertygfatotal` is highly skewed (γ1 = 24.30204906)	Skewed
`propertygfabuilding_s` is highly skewed (γ1 = 27.86973423)	Skewed
`largestpropertyusetypegfa` is highly skewed (γ1 = 30.23012777)	Skewed
`propertygfaparking` has 2827 (85.0%) zeros	Zeros

Reproduction

Analysis started	2023-07-10 19:06:17.999661
Analysis finished	2023-07-10 19:07:00.264436
Duration	42.26 seconds
Software version	ydata-profiling vv4.3.1
Download configuration	config.json

buildingtype
Categorical

HIGH CORRELATION

Distinct	8
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	26.1 KiB

NonResidential	1439
Multifamily LR (1-4)	996
Multifamily MR (5-9)	578
Multifamily HR (10+)	109
SPS-District K-12	94
Other values (3)	109

Length

Max length	20
Median length	20
Mean length	17.166015
Min length	6

Characters and Unicode

Total characters	57077
Distinct characters	40
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	NonResidential
2nd row	NonResidential
3rd row	NonResidential
4th row	NonResidential
5th row	NonResidential

Common Values

Value	Count	Frequency (%)
NonResidential	1439	43.3%
Multifamily LR (1-4)	996	30.0%
Multifamily MR (5-9)	578	17.4%
Multifamily HR (10+)	109	3.3%
SPS-District K-12	94	2.8%
Nonresidential COS	84	2.5%
Campus	24	0.7%
Nonresidential WA	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
multifamily	1683	24.5%
nonresidential	1524	22.2%
lr	996	14.5%
1-4	996	14.5%
mr	578	8.4%
5-9	578	8.4%
hr	109	1.6%
10	109	1.6%
sps-district	94	1.4%
k-12	94	1.4%
Other values (3)	109	1.6%

Most occurring characters

Value	Count	Frequency (%)
i	6602	11.6%
l	4890	8.6%
	3545	6.2%
t	3395	5.9%
a	3231	5.7%
R	3122	5.5%
n	3048	5.3%
e	3048	5.3%
M	2261	4.0%
-	1762	3.1%
Other values (30)	22173	38.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	35981	63.0%
Uppercase Letter	8760	15.3%
Decimal Number	3554	6.2%
Space Separator	3545	6.2%
Dash Punctuation	1762	3.1%
Open Punctuation	1683	2.9%
Close Punctuation	1683	2.9%
Math Symbol	109	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	6602	18.3%
l	4890	13.6%
t	3395	9.4%
a	3231	9.0%
n	3048	8.5%
e	3048	8.5%
u	1707	4.7%
m	1707	4.7%
f	1683	4.7%
y	1683	4.7%
Other values (6)	4987	13.9%

Uppercase Letter

Value	Count	Frequency (%)
R	3122	35.6%
M	2261	25.8%
N	1524	17.4%
L	996	11.4%
S	272	3.1%
H	109	1.2%
C	108	1.2%
K	94	1.1%
P	94	1.1%
D	94	1.1%
Other values (3)	86	1.0%

Decimal Number

Value	Count	Frequency (%)
1	1199	33.7%
4	996	28.0%
5	578	16.3%
9	578	16.3%
0	109	3.1%
2	94	2.6%

Space Separator

Value	Count	Frequency (%)
	3545	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1762	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1683	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1683	100.0%

Math Symbol

Value	Count	Frequency (%)
+	109	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	44741	78.4%
Common	12336	21.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	6602	14.8%
l	4890	10.9%
t	3395	7.6%
a	3231	7.2%
R	3122	7.0%
n	3048	6.8%
e	3048	6.8%
M	2261	5.1%
u	1707	3.8%
m	1707	3.8%
Other values (19)	11730	26.2%

Common

Value	Count	Frequency (%)
	3545	28.7%
-	1762	14.3%
(	1683	13.6%
)	1683	13.6%
1	1199	9.7%
4	996	8.1%
5	578	4.7%
9	578	4.7%
0	109	0.9%
+	109	0.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	57077	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	6602	11.6%
l	4890	8.6%
	3545	6.2%
t	3395	5.9%
a	3231	5.7%
R	3122	5.5%
n	3048	5.3%
e	3048	5.3%
M	2261	4.0%
-	1762	3.1%
Other values (30)	22173	38.8%

primarypropertytype
Categorical

HIGH CORRELATION

Distinct	24
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	26.1 KiB

Low-Rise Multifamily	966
Mid-Rise Multifamily	561
Small- and Mid-Sized Office	288
Other	250
Warehouse	187
Other values (19)	1073

Length

Max length	27
Median length	22
Mean length	17.193383
Min length	5

Characters and Unicode

Total characters	57168
Distinct characters	43
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Hotel
2nd row	Hotel
3rd row	Hotel
4th row	Hotel
5th row	Hotel

Common Values

Value	Count	Frequency (%)
Low-Rise Multifamily	966	29.1%
Mid-Rise Multifamily	561	16.9%
Small- and Mid-Sized Office	288	8.7%
Other	250	7.5%
Warehouse	187	5.6%
Large Office	170	5.1%
K-12 School	134	4.0%
Mixed Use Property	132	4.0%
High-Rise Multifamily	104	3.1%
Retail Store	89	2.7%
Other values (14)	444	13.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
multifamily	1631	23.6%
low-rise	966	14.0%
mid-rise	561	8.1%
office	500	7.2%
small	288	4.2%
and	288	4.2%
mid-sized	288	4.2%
other	250	3.6%
warehouse	199	2.9%
large	170	2.5%
Other values (28)	1767	25.6%

Most occurring characters

Value	Count	Frequency (%)
i	7501	13.1%
e	4476	7.8%
l	4357	7.6%
	3583	6.3%
a	3002	5.3%
t	2755	4.8%
f	2671	4.7%
M	2651	4.6%
-	2369	4.1%
s	2154	3.8%
Other values (33)	21649	37.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	42381	74.1%
Uppercase Letter	8528	14.9%
Space Separator	3583	6.3%
Dash Punctuation	2369	4.1%
Decimal Number	268	0.5%
Other Punctuation	39	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	7501	17.7%
e	4476	10.6%
l	4357	10.3%
a	3002	7.1%
t	2755	6.5%
f	2671	6.3%
s	2154	5.1%
o	2078	4.9%
m	2048	4.8%
u	1979	4.7%
Other values (14)	9360	22.1%

Uppercase Letter

Value	Count	Frequency (%)
M	2651	31.1%
R	1767	20.7%
L	1146	13.4%
S	978	11.5%
O	750	8.8%
W	268	3.1%
H	213	2.5%
U	157	1.8%
C	143	1.7%
K	134	1.6%
Other values (4)	321	3.8%

Decimal Number

Value	Count	Frequency (%)
1	134	50.0%
2	134	50.0%

Space Separator

Value	Count	Frequency (%)
	3583	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2369	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	39	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	50909	89.1%
Common	6259	10.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	7501	14.7%
e	4476	8.8%
l	4357	8.6%
a	3002	5.9%
t	2755	5.4%
f	2671	5.2%
M	2651	5.2%
s	2154	4.2%
o	2078	4.1%
m	2048	4.0%
Other values (28)	17216	33.8%

Common

Value	Count	Frequency (%)
	3583	57.2%
-	2369	37.8%
1	134	2.1%
2	134	2.1%
/	39	0.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	57168	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	7501	13.1%
e	4476	7.8%
l	4357	7.6%
	3583	6.3%
a	3002	5.3%
t	2755	4.8%
f	2671	4.7%
M	2651	4.6%
-	2369	4.1%
s	2154	3.8%
Other values (33)	21649	37.9%

taxparcelidentificationnumber
Text

Distinct	3219
Distinct (%)	96.8%
Missing	0
Missing (%)	0.0%
Memory size	26.1 KiB

Length

Max length	25
Median length	10
Mean length	10.005113
Min length	9

Characters and Unicode

Total characters	33267
Distinct characters	15
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3143 ?
Unique (%)	94.5%

Sample

1st row	0659000030
2nd row	0659000220
3rd row	0659000475
4th row	0659000640
5th row	0659000970

Value	Count	Frequency (%)
1625049001	8	0.2%
0925049346	5	0.2%
0002400002	5	0.2%
3224049012	5	0.2%
7666203240	4	0.1%
3624039009	4	0.1%
0225049077	3	0.1%
7954000005	3	0.1%
5036300605	3	0.1%
8809700040	3	0.1%
Other values (3210)	3284	98.7%

Most occurring characters

Value	Count	Frequency (%)
0	11170	33.6%
2	3118	9.4%
5	2903	8.7%
6	2674	8.0%
1	2654	8.0%
9	2353	7.1%
7	2333	7.0%
4	2134	6.4%
3	2040	6.1%
8	1881	5.7%
Other values (5)	7	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	33260	> 99.9%
Lowercase Letter	3	< 0.1%
Space Separator	2	< 0.1%
Dash Punctuation	2	< 0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	11170	33.6%
2	3118	9.4%
5	2903	8.7%
6	2674	8.0%
1	2654	8.0%
9	2353	7.1%
7	2333	7.0%
4	2134	6.4%
3	2040	6.1%
8	1881	5.7%

Lowercase Letter

Value	Count	Frequency (%)
a	1	33.3%
n	1	33.3%
d	1	33.3%

Space Separator

Value	Count	Frequency (%)
	2	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	33264	> 99.9%
Latin	3	< 0.1%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	11170	33.6%
2	3118	9.4%
5	2903	8.7%
6	2674	8.0%
1	2654	8.0%
9	2353	7.1%
7	2333	7.0%
4	2134	6.4%
3	2040	6.1%
8	1881	5.7%
Other values (2)	4	< 0.1%

Latin

Value	Count	Frequency (%)
a	1	33.3%
n	1	33.3%
d	1	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	33267	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	11170	33.6%
2	3118	9.4%
5	2903	8.7%
6	2674	8.0%
1	2654	8.0%
9	2353	7.1%
7	2333	7.0%
4	2134	6.4%
3	2040	6.1%
8	1881	5.7%
Other values (5)	7	< 0.1%

councildistrictcode
Real number (ℝ)

HIGH CORRELATION

Distinct	7
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.4439098

Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.1 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	4
Q3	7
95-th percentile	7
Maximum	7
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.1189641
Coefficient of variation (CV)	0.47682428
Kurtosis	-1.4456471
Mean	4.4439098
Median Absolute Deviation (MAD)	2
Skewness	-0.072158098
Sum	14776
Variance	4.4900088
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
7	1022	30.7%
3	587	17.7%
2	503	15.1%
4	360	10.8%
5	333	10.0%
1	274	8.2%
6	246	7.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	274	8.2%
2	503	15.1%
3	587	17.7%
4	360	10.8%
5	333	10.0%
6	246	7.4%
7	1022	30.7%

Value	Count	Frequency (%)
7	1022	30.7%
6	246	7.4%
5	333	10.0%
4	360	10.8%
3	587	17.7%
2	503	15.1%
1	274	8.2%

neighborhood
Categorical

HIGH CORRELATION

Distinct	13
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	26.1 KiB

DOWNTOWN	562
EAST	448
MAGNOLIA / QUEEN ANNE	417
GREATER DUWAMISH	371
NORTHEAST	274
Other values (8)	1253

Length

Max length	21
Median length	10
Mean length	10.114586
Min length	4

Characters and Unicode

Total characters	33631
Distinct characters	21
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	DOWNTOWN
2nd row	DOWNTOWN
3rd row	DOWNTOWN
4th row	DOWNTOWN
5th row	DOWNTOWN

Common Values

Value	Count	Frequency (%)
DOWNTOWN	562	16.9%
EAST	448	13.5%
MAGNOLIA / QUEEN ANNE	417	12.5%
GREATER DUWAMISH	371	11.2%
NORTHEAST	274	8.2%
LAKE UNION	250	7.5%
NORTHWEST	219	6.6%
NORTH	183	5.5%
SOUTHWEST	158	4.8%
BALLARD	133	4.0%
Other values (3)	310	9.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
downtown	562	10.8%
east	448	8.6%
magnolia	417	8.0%
	417	8.0%
queen	417	8.0%
anne	417	8.0%
greater	371	7.1%
duwamish	371	7.1%
northeast	274	5.3%
union	250	4.8%
Other values (8)	1253	24.1%

Most occurring characters

Value	Count	Frequency (%)
N	4098	12.2%
E	3737	11.1%
A	3456	10.3%
T	3186	9.5%
O	2720	8.1%
	1872	5.6%
W	1872	5.6%
S	1818	5.4%
R	1766	5.3%
H	1300	3.9%
Other values (11)	7806	23.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	31342	93.2%
Space Separator	1872	5.6%
Other Punctuation	417	1.2%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	4098	13.1%
E	3737	11.9%
A	3456	11.0%
T	3186	10.2%
O	2720	8.7%
W	1872	6.0%
S	1818	5.8%
R	1766	5.6%
H	1300	4.1%
U	1291	4.1%
Other values (9)	6098	19.5%

Space Separator

Value	Count	Frequency (%)
	1872	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	417	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	31342	93.2%
Common	2289	6.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	4098	13.1%
E	3737	11.9%
A	3456	11.0%
T	3186	10.2%
O	2720	8.7%
W	1872	6.0%
S	1818	5.8%
R	1766	5.6%
H	1300	4.1%
U	1291	4.1%
Other values (9)	6098	19.5%

Common

Value	Count	Frequency (%)
	1872	81.8%
/	417	18.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	33631	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	4098	12.2%
E	3737	11.1%
A	3456	10.3%
T	3186	9.5%
O	2720	8.1%
	1872	5.6%
W	1872	5.6%
S	1818	5.4%
R	1766	5.3%
H	1300	3.9%
Other values (11)	7806	23.2%

numberofbuildings
Real number (ℝ)

SKEWED

Distinct	16
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.1344361

Minimum	1
Maximum	111
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.1 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	1
Maximum	111
Range	110
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.1127163
Coefficient of variation (CV)	1.8623493
Kurtosis	2213.412
Mean	1.1344361
Median Absolute Deviation (MAD)	0
Skewness	43.650879
Sum	3772
Variance	4.4635701
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
1	3226	97.0%
2	36	1.1%
3	22	0.7%
4	12	0.4%
5	9	0.3%
6	5	0.2%
8	3	0.1%
14	2	0.1%
9	2	0.1%
10	2	0.1%
Other values (6)	6	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	3226	97.0%
2	36	1.1%
3	22	0.7%
4	12	0.4%
5	9	0.3%
6	5	0.2%
7	1	< 0.1%
8	3	0.1%
9	2	0.1%
10	2	0.1%

Value	Count	Frequency (%)
111	1	< 0.1%
27	1	< 0.1%
23	1	< 0.1%
16	1	< 0.1%
14	2	0.1%
11	1	< 0.1%
10	2	0.1%
9	2	0.1%
8	3	0.1%
7	1	< 0.1%

numberoffloors
Real number (ℝ)

Distinct	49
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.7287218

Minimum	1
Maximum	99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.1 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	5
95-th percentile	12
Maximum	99
Range	98
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	5.516339
Coefficient of variation (CV)	1.1665603
Kurtosis	55.781252
Mean	4.7287218
Median Absolute Deviation (MAD)	2
Skewness	5.9209841
Sum	15723
Variance	30.429996
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
3	680	20.5%
4	676	20.3%
1	474	14.3%
2	432	13.0%
6	303	9.1%
5	294	8.8%
7	146	4.4%
8	63	1.9%
10	32	1.0%
11	32	1.0%
Other values (39)	193	5.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	474	14.3%
2	432	13.0%
3	680	20.5%
4	676	20.3%
5	294	8.8%
6	303	9.1%
7	146	4.4%
8	63	1.9%
9	18	0.5%
10	32	1.0%

Value	Count	Frequency (%)
99	1	< 0.1%
76	1	< 0.1%
63	1	< 0.1%
56	1	< 0.1%
55	1	< 0.1%
49	1	< 0.1%
47	1	< 0.1%
46	1	< 0.1%
42	6	0.2%
41	3	0.1%

propertygfatotal
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	3152
Distinct (%)	94.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	95117.731

Minimum	11285
Maximum	9320156
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.1 KiB

Quantile statistics

Minimum	11285
5-th percentile	21300.6
Q1	28492
median	44432
Q3	91560
95-th percentile	320721.4
Maximum	9320156
Range	9308871
Interquartile range (IQR)	63068

Descriptive statistics

Standard deviation	219227.93
Coefficient of variation (CV)	2.3048061
Kurtosis	953.47919
Mean	95117.731
Median Absolute Deviation (MAD)	20017
Skewness	24.302049
Sum	3.1626646 × 10⁸
Variance	4.8060884 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
36000	9	0.3%
25920	8	0.2%
21600	7	0.2%
28800	7	0.2%
24000	6	0.2%
30240	4	0.1%
22320	4	0.1%
30720	4	0.1%
43380	3	0.1%
21200	3	0.1%
Other values (3142)	3270	98.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11285	1	< 0.1%
11685	1	< 0.1%
11968	1	< 0.1%
12294	1	< 0.1%
12769	1	< 0.1%
13157	1	< 0.1%
13661	1	< 0.1%
14101	1	< 0.1%
15398	1	< 0.1%
16000	1	< 0.1%

Value	Count	Frequency (%)
9320156	1	< 0.1%
2200000	1	< 0.1%
1952220	1	< 0.1%
1765970	1	< 0.1%
1605578	1	< 0.1%
1592914	1	< 0.1%
1585960	1	< 0.1%
1536606	1	< 0.1%
1400000	1	< 0.1%
1380959	1	< 0.1%

propertygfaparking
Real number (ℝ)

ZEROS

Distinct	490
Distinct (%)	14.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8092.6767

Minimum	0
Maximum	512608
Zeros	2827
Zeros (%)	85.0%
Negative	0
Negative (%)	0.0%
Memory size	26.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	48074.4
Maximum	512608
Range	512608
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	32553.075
Coefficient of variation (CV)	4.022535
Kurtosis	58.120796
Mean	8092.6767
Median Absolute Deviation (MAD)	0
Skewness	6.6047898
Sum	26908150
Variance	1.0597027 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2827	85.0%
13320	3	0.1%
12960	2	0.1%
10800	2	0.1%
100176	2	0.1%
22000	2	0.1%
30000	2	0.1%
25800	2	0.1%
20416	2	0.1%
3029	1	< 0.1%
Other values (480)	480	14.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2827	85.0%
38	1	< 0.1%
260	1	< 0.1%
415	1	< 0.1%
604	1	< 0.1%
756	1	< 0.1%
800	1	< 0.1%
919	1	< 0.1%
1263	1	< 0.1%
1392	1	< 0.1%

Value	Count	Frequency (%)
512608	1	< 0.1%
407795	1	< 0.1%
389860	1	< 0.1%
368980	1	< 0.1%
335109	1	< 0.1%
327680	1	< 0.1%
319400	1	< 0.1%
303707	1	< 0.1%
285688	1	< 0.1%
285000	1	< 0.1%

propertygfabuilding_s
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	3148
Distinct (%)	94.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	87025.055

Minimum	3636
Maximum	9320156
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.1 KiB

Quantile statistics

Minimum	3636
5-th percentile	21036.8
Q1	27770
median	43330
Q3	84739
95-th percentile	283310.6
Maximum	9320156
Range	9316520
Interquartile range (IQR)	56969

Descriptive statistics

Standard deviation	208189.04
Coefficient of variation (CV)	2.3922886
Kurtosis	1173.0254
Mean	87025.055
Median Absolute Deviation (MAD)	19050
Skewness	27.869734
Sum	2.8935831 × 10⁸
Variance	4.3342678 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
36000	9	0.3%
25920	8	0.2%
28800	7	0.2%
21600	7	0.2%
24000	6	0.2%
30240	4	0.1%
30720	4	0.1%
22320	4	0.1%
22344	3	0.1%
25200	3	0.1%
Other values (3138)	3270	98.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3636	1	< 0.1%
10925	1	< 0.1%
11285	1	< 0.1%
11440	1	< 0.1%
11685	1	< 0.1%
11968	1	< 0.1%
12294	1	< 0.1%
12769	1	< 0.1%
12806	1	< 0.1%
13157	1	< 0.1%

Value	Count	Frequency (%)
9320156	1	< 0.1%
2200000	1	< 0.1%
1765970	1	< 0.1%
1632820	1	< 0.1%
1592914	1	< 0.1%
1380959	1	< 0.1%
1323055	1	< 0.1%
1258280	1	< 0.1%
1215718	1	< 0.1%
1195387	1	< 0.1%

listofallpropertyusetypes
Text

Distinct	460
Distinct (%)	13.8%
Missing	0
Missing (%)	0.0%
Memory size	26.1 KiB

Length

Max length	255
Median length	162
Mean length	25.96
Min length	5

Characters and Unicode

Total characters	86317
Distinct characters	52
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	308 ?
Unique (%)	9.3%

Sample

1st row	Hotel
2nd row	Hotel, Parking, Restaurant
3rd row	Hotel
4th row	Hotel
5th row	Hotel, Parking, Swimming Pool

Value	Count	Frequency (%)
multifamily	1688	17.3%
housing	1688	17.3%
parking	1078	11.0%
office	951	9.7%
store	465	4.8%
other	413	4.2%
retail	398	4.1%
warehouse	277	2.8%
non-refrigerated	260	2.7%
	179	1.8%
Other values (96)	2385	24.4%

Most occurring characters

Value	Count	Frequency (%)
i	9267	10.7%
	6457	7.5%
e	5623	6.5%
a	5191	6.0%
l	4895	5.7%
t	4883	5.7%
u	4214	4.9%
r	4202	4.9%
n	4130	4.8%
o	3961	4.6%
Other values (42)	33494	38.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	65618	76.0%
Uppercase Letter	10235	11.9%
Space Separator	6457	7.5%
Other Punctuation	3024	3.5%
Dash Punctuation	625	0.7%
Decimal Number	284	0.3%
Open Punctuation	37	< 0.1%
Close Punctuation	37	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	9267	14.1%
e	5623	8.6%
a	5191	7.9%
l	4895	7.5%
t	4883	7.4%
u	4214	6.4%
r	4202	6.4%
n	4130	6.3%
o	3961	6.0%
f	3933	6.0%
Other values (12)	15319	23.3%

Uppercase Letter

Value	Count	Frequency (%)
H	1887	18.4%
M	1837	17.9%
O	1386	13.5%
P	1225	12.0%
S	1015	9.9%
R	953	9.3%
W	353	3.4%
C	337	3.3%
N	266	2.6%
F	221	2.2%
Other values (11)	755	7.4%

Other Punctuation

Value	Count	Frequency (%)
,	2653	87.7%
/	359	11.9%
&	12	0.4%

Decimal Number

Value	Count	Frequency (%)
2	142	50.0%
1	142	50.0%

Space Separator

Value	Count	Frequency (%)
	6457	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	625	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	37	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	37	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	75853	87.9%
Common	10464	12.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	9267	12.2%
e	5623	7.4%
a	5191	6.8%
l	4895	6.5%
t	4883	6.4%
u	4214	5.6%
r	4202	5.5%
n	4130	5.4%
o	3961	5.2%
f	3933	5.2%
Other values (33)	25554	33.7%

Common

Value	Count	Frequency (%)
	6457	61.7%
,	2653	25.4%
-	625	6.0%
/	359	3.4%
2	142	1.4%
1	142	1.4%
(	37	0.4%
)	37	0.4%
&	12	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	86317	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	9267	10.7%
	6457	7.5%
e	5623	6.5%
a	5191	6.0%
l	4895	5.7%
t	4883	5.7%
u	4214	4.9%
r	4202	4.9%
n	4130	4.8%
o	3961	4.6%
Other values (42)	33494	38.8%

largestpropertyusetype
Text

Distinct	55
Distinct (%)	1.7%
Missing	11
Missing (%)	0.3%
Memory size	26.1 KiB

Length

Max length	52
Median length	19
Mean length	16.287266
Min length	5

Characters and Unicode

Total characters	53976
Distinct characters	51
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8 ?
Unique (%)	0.2%

Sample

1st row	Hotel
2nd row	Hotel
3rd row	Hotel
4th row	Hotel
5th row	Hotel

Value	Count	Frequency (%)
multifamily	1649	27.1%
housing	1649	27.1%
office	536	8.8%
warehouse	211	3.5%
non-refrigerated	199	3.3%
other	174	2.9%
store	137	2.3%
k-12	134	2.2%
school	134	2.2%
facility	98	1.6%
Other values (78)	1158	19.0%

Most occurring characters

Value	Count	Frequency (%)
i	6754	12.5%
l	4084	7.6%
u	3756	7.0%
t	3060	5.7%
o	3033	5.6%
e	3007	5.6%
f	2973	5.5%
a	2776	5.1%
	2765	5.1%
n	2368	4.4%
Other values (41)	19400	35.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	43897	81.3%
Uppercase Letter	6378	11.8%
Space Separator	2765	5.1%
Dash Punctuation	439	0.8%
Decimal Number	268	0.5%
Other Punctuation	195	0.4%
Open Punctuation	17	< 0.1%
Close Punctuation	17	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	6754	15.4%
l	4084	9.3%
u	3756	8.6%
t	3060	7.0%
o	3033	6.9%
e	3007	6.9%
f	2973	6.8%
a	2776	6.3%
n	2368	5.4%
s	2170	4.9%
Other values (11)	9916	22.6%

Uppercase Letter

Value	Count	Frequency (%)
H	1779	27.9%
M	1734	27.2%
O	722	11.3%
S	467	7.3%
R	390	6.1%
W	281	4.4%
N	199	3.1%
C	198	3.1%
K	134	2.1%
F	109	1.7%
Other values (11)	365	5.7%

Other Punctuation

Value	Count	Frequency (%)
/	165	84.6%
,	20	10.3%
&	10	5.1%

Decimal Number

Value	Count	Frequency (%)
2	134	50.0%
1	134	50.0%

Space Separator

Value	Count	Frequency (%)
	2765	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	439	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	17	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	17	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	50275	93.1%
Common	3701	6.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	6754	13.4%
l	4084	8.1%
u	3756	7.5%
t	3060	6.1%
o	3033	6.0%
e	3007	6.0%
f	2973	5.9%
a	2776	5.5%
n	2368	4.7%
s	2170	4.3%
Other values (32)	16294	32.4%

Common

Value	Count	Frequency (%)
	2765	74.7%
-	439	11.9%
/	165	4.5%
2	134	3.6%
1	134	3.6%
,	20	0.5%
(	17	0.5%
)	17	0.5%
&	10	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	53976	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	6754	12.5%
l	4084	7.6%
u	3756	7.0%
t	3060	5.7%
o	3033	5.6%
e	3007	5.6%
f	2973	5.5%
a	2776	5.1%
	2765	5.1%
n	2368	4.4%
Other values (41)	19400	35.9%

largestpropertyusetypegfa
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	3087
Distinct (%)	93.2%
Missing	11
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	79274.199

Minimum	5656
Maximum	9320156
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.1 KiB

Quantile statistics

Minimum	5656
5-th percentile	17521.8
Q1	25138.75
median	39956
Q3	77038.25
95-th percentile	244684.8
Maximum	9320156
Range	9314500
Interquartile range (IQR)	51899.5

Descriptive statistics

Standard deviation	202169.86
Coefficient of variation (CV)	2.5502605
Kurtosis	1324.8584
Mean	79274.199
Median Absolute Deviation (MAD)	17627.5
Skewness	30.230128
Sum	2.627147 × 10⁸
Variance	4.0872653 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24000	9	0.3%
22000	8	0.2%
30000	8	0.2%
20000	7	0.2%
21600	7	0.2%
45000	5	0.2%
15000	5	0.2%
24288	5	0.2%
36000	5	0.2%
28800	5	0.2%
Other values (3077)	3250	97.7%
(Missing)	11	0.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5656	1	< 0.1%
6455	1	< 0.1%
6601	1	< 0.1%
6900	1	< 0.1%
7245	1	< 0.1%
7387	1	< 0.1%
7501	1	< 0.1%
7583	1	< 0.1%
7758	1	< 0.1%
8061	1	< 0.1%

Value	Count	Frequency (%)
9320156	1	< 0.1%
1719643	1	< 0.1%
1680937	1	< 0.1%
1639334	1	< 0.1%
1585960	1	< 0.1%
1350182	1	< 0.1%
1314475	1	< 0.1%
1191115	1	< 0.1%
1172127	1	< 0.1%
1011135	1	< 0.1%

energystarscore
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	100
Distinct (%)	4.0%
Missing	819
Missing (%)	24.6%
Infinite	0
Infinite (%)	0.0%
Mean	67.821229

Minimum	1
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.1 KiB

Quantile statistics

Minimum	1
5-th percentile	12
Q1	53
median	75
Q3	90
95-th percentile	99
Maximum	100
Range	99
Interquartile range (IQR)	37

Descriptive statistics

Standard deviation	26.703263
Coefficient of variation (CV)	0.39373015
Kurtosis	-0.21900622
Mean	67.821229
Median Absolute Deviation (MAD)	17
Skewness	-0.85720143
Sum	169960
Variance	713.06424
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	91	2.7%
98	72	2.2%
96	64	1.9%
89	58	1.7%
93	57	1.7%
92	53	1.6%
95	51	1.5%
94	49	1.5%
91	49	1.5%
97	48	1.4%
Other values (90)	1914	57.6%
(Missing)	819	24.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	33	1.0%
2	10	0.3%
3	13	0.4%
4	5	0.2%
5	8	0.2%
6	8	0.2%
7	10	0.3%
8	10	0.3%
9	5	0.2%
10	10	0.3%

Value	Count	Frequency (%)
100	91	2.7%
99	48	1.4%
98	72	2.2%
97	48	1.4%
96	64	1.9%
95	51	1.5%
94	49	1.5%
93	57	1.7%
92	53	1.6%
91	49	1.5%

steamuse
Boolean

IMBALANCE

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.4 KiB

False	3196
True	129

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	3196	96.1%
True	129	3.9%

electricity
Boolean

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.4 KiB

True	3320
False	5

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	3320	99.8%
False	5	0.2%

naturalgas
Boolean

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.4 KiB

True	2094
False	1231

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	2094	63.0%
False	1231	37.0%

defaultdata
Boolean

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.4 KiB

False	3215
True	110

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	3215	96.7%
True	110	3.3%

compliancestatus
Categorical

CONSTANT MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	121
Missing (%)	3.6%
Memory size	26.1 KiB

Compliant	3204

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	28836
Distinct characters	9
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Compliant
2nd row	Compliant
3rd row	Compliant
4th row	Compliant
5th row	Compliant

Common Values

Value	Count	Frequency (%)
Compliant	3204	96.4%
(Missing)	121	3.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
compliant	3204	100.0%

Most occurring characters

Value	Count	Frequency (%)
C	3204	11.1%
o	3204	11.1%
m	3204	11.1%
p	3204	11.1%
l	3204	11.1%
i	3204	11.1%
a	3204	11.1%
n	3204	11.1%
t	3204	11.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	25632	88.9%
Uppercase Letter	3204	11.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	3204	12.5%
m	3204	12.5%
p	3204	12.5%
l	3204	12.5%
i	3204	12.5%
a	3204	12.5%
n	3204	12.5%
t	3204	12.5%

Uppercase Letter

Value	Count	Frequency (%)
C	3204	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	28836	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	3204	11.1%
o	3204	11.1%
m	3204	11.1%
p	3204	11.1%
l	3204	11.1%
i	3204	11.1%
a	3204	11.1%
n	3204	11.1%
t	3204	11.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	28836	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	3204	11.1%
o	3204	11.1%
m	3204	11.1%
p	3204	11.1%
l	3204	11.1%
i	3204	11.1%
a	3204	11.1%
n	3204	11.1%
t	3204	11.1%

totalghgemissions
Real number (ℝ)

HIGH CORRELATION

Distinct	2789
Distinct (%)	83.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	120.47031

Minimum	0.4
Maximum	16870.98
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.1 KiB

Quantile statistics

Minimum	0.4
5-th percentile	3.94
Q1	9.72
median	34.22
Q3	94.23
95-th percentile	392.888
Maximum	16870.98
Range	16870.58
Interquartile range (IQR)	84.51

Descriptive statistics

Standard deviation	541.93744
Coefficient of variation (CV)	4.4985144
Kurtosis	469.83732
Mean	120.47031
Median Absolute Deviation (MAD)	28.06
Skewness	19.386458
Sum	400563.79
Variance	293696.19
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.95	7	0.2%
4.2	6	0.2%
4.43	5	0.2%
4.76	5	0.2%
9.29	5	0.2%
5.07	5	0.2%
3.63	5	0.2%
5.46	5	0.2%
4.52	5	0.2%
4.8	5	0.2%
Other values (2779)	3272	98.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.4	1	< 0.1%
0.63	1	< 0.1%
0.68	1	< 0.1%
0.75	1	< 0.1%
0.79	1	< 0.1%
0.81	1	< 0.1%
0.82	1	< 0.1%
0.86	1	< 0.1%
0.87	1	< 0.1%
0.89	1	< 0.1%

Value	Count	Frequency (%)
16870.98	1	< 0.1%
12307.16	1	< 0.1%
11140.56	1	< 0.1%
10734.57	1	< 0.1%
8145.52	1	< 0.1%
6330.91	1	< 0.1%
4906.33	1	< 0.1%
3995.45	1	< 0.1%
3768.66	1	< 0.1%
3278.11	1	< 0.1%

zipcode
Real number (ℝ)

Distinct	60
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	98117.006

Minimum	98006
Maximum	98272
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.1 KiB

Quantile statistics

Minimum	98006
5-th percentile	98101
Q1	98105
median	98115
Q3	98122
95-th percentile	98144
Maximum	98272
Range	266
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	18.677249
Coefficient of variation (CV)	0.0001903569
Kurtosis	10.429189
Mean	98117.006
Median Absolute Deviation (MAD)	10
Skewness	1.9937018
Sum	3.2623904 × 10⁸
Variance	348.83964
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
98109	292	8.8%
98104	246	7.4%
98122	239	7.2%
98101	225	6.8%
98105	186	5.6%
98121	184	5.5%
98134	184	5.5%
98102	166	5.0%
98119	164	4.9%
98103	160	4.8%
Other values (50)	1279	38.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
98006	1	< 0.1%
98011	1	< 0.1%
98012	1	< 0.1%
98013	2	0.1%
98020	1	< 0.1%
98028	1	< 0.1%
98033	1	< 0.1%
98040	1	< 0.1%
98053	1	< 0.1%
98070	1	< 0.1%

Value	Count	Frequency (%)
98272	1	< 0.1%
98204	1	< 0.1%
98199	70	2.1%
98198	1	< 0.1%
98195	10	0.3%
98191	1	< 0.1%
98185	1	< 0.1%
98181	1	< 0.1%
98178	4	0.1%
98177	2	0.1%

latitude
Real number (ℝ)

HIGH CORRELATION

Distinct	2841
Distinct (%)	85.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	47.624081

Minimum	47.49917
Maximum	47.73387
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.1 KiB

Quantile statistics

Minimum	47.49917
5-th percentile	47.541566
Q1	47.60001
median	47.61875
Q3	47.65715
95-th percentile	47.712964
Maximum	47.73387
Range	0.2347
Interquartile range (IQR)	0.05714

Descriptive statistics

Standard deviation	0.047774613
Coefficient of variation (CV)	0.0010031608
Kurtosis	-0.14284519
Mean	47.624081
Median Absolute Deviation (MAD)	0.02847
Skewness	0.13624016
Sum	158350.07
Variance	0.0022824136
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
47.66246	9	0.3%
47.61598	7	0.2%
47.62208	6	0.2%
47.61543	5	0.2%
47.52549	5	0.2%
47.62395	5	0.2%
47.59938	4	0.1%
47.60071	4	0.1%
47.60427	4	0.1%
47.62014	4	0.1%
Other values (2831)	3272	98.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
47.49917	1	< 0.1%
47.50061895	1	< 0.1%
47.50224	1	< 0.1%
47.50959	1	< 0.1%
47.5097	1	< 0.1%
47.51018	1	< 0.1%
47.51042	1	< 0.1%
47.51098	1	< 0.1%
47.51104	1	< 0.1%
47.51127	2	0.1%

Value	Count	Frequency (%)
47.73387	1	< 0.1%
47.73375	1	< 0.1%
47.73368	1	< 0.1%
47.7336	1	< 0.1%
47.73357	1	< 0.1%
47.73351	1	< 0.1%
47.73331	1	< 0.1%
47.73316	1	< 0.1%
47.73315	1	< 0.1%
47.73279	1	< 0.1%

longitude
Real number (ℝ)

Distinct	2625
Distinct (%)	78.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-122.33476

Minimum	-122.41425
Maximum	-122.22097
Zeros	0
Zeros (%)	0.0%
Negative	3325
Negative (%)	100.0%
Memory size	26.1 KiB

Quantile statistics

Minimum	-122.41425
5-th percentile	-122.38652
Q1	-122.35056
median	-122.33248
Q3	-122.31947
95-th percentile	-122.28971
Maximum	-122.22097
Range	0.1932841
Interquartile range (IQR)	0.03109

Descriptive statistics

Standard deviation	0.027177828
Coefficient of variation (CV)	-0.0002221595
Kurtosis	0.26702149
Mean	-122.33476
Median Absolute Deviation (MAD)	0.0151
Skewness	-0.13538442
Sum	-406763.06
Variance	0.00073863435
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-122.29898	8	0.2%
-122.35398	7	0.2%
-122.32468	6	0.2%
-122.33369	6	0.2%
-122.31769	5	0.2%
-122.32417	5	0.2%
-122.32592	5	0.2%
-122.33379	5	0.2%
-122.33064	5	0.2%
-122.32717	4	0.1%
Other values (2615)	3269	98.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-122.41425	1	< 0.1%
-122.41182	1	< 0.1%
-122.41178	1	< 0.1%
-122.41169	1	< 0.1%
-122.41037	1	< 0.1%
-122.41036	1	< 0.1%
-122.41031	1	< 0.1%
-122.40976	1	< 0.1%
-122.40974	1	< 0.1%
-122.40901	1	< 0.1%

Value	Count	Frequency (%)
-122.2209659	1	< 0.1%
-122.25864	1	< 0.1%
-122.26028	1	< 0.1%
-122.26034	1	< 0.1%
-122.26166	2	0.1%
-122.26172	1	< 0.1%
-122.26177	1	< 0.1%
-122.2618	1	< 0.1%
-122.26216	1	< 0.1%
-122.26223	1	< 0.1%

age
Real number (ℝ)

Distinct	113
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54.281203

Minimum	8
Maximum	123
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.1 KiB

Quantile statistics

Minimum	8
5-th percentile	11
Q1	26
median	48
Q3	75
95-th percentile	115
Maximum	123
Range	115
Interquartile range (IQR)	49

Descriptive statistics

Standard deviation	33.023075
Coefficient of variation (CV)	0.60837036
Kurtosis	-0.86432259
Mean	54.281203
Median Absolute Deviation (MAD)	24
Skewness	0.54349654
Sum	180485
Variance	1090.5235
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
23	71	2.1%
9	67	2.0%
34	64	1.9%
24	64	1.9%
15	64	1.9%
35	63	1.9%
55	63	1.9%
22	59	1.8%
21	58	1.7%
33	58	1.7%
Other values (103)	2694	81.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8	35	1.1%
9	67	2.0%
10	50	1.5%
11	35	1.1%
12	15	0.5%
13	24	0.7%
14	41	1.2%
15	64	1.9%
16	42	1.3%
17	45	1.4%

Value	Count	Frequency (%)
123	53	1.6%
122	8	0.2%
121	11	0.3%
120	3	0.1%
119	14	0.4%
118	9	0.3%
117	18	0.5%
116	31	0.9%
115	27	0.8%
114	31	0.9%

Auto

Heatmap
Table

	councildistrictcode	numberofbuildings	numberoffloors	propertygfatotal	propertygfaparking	propertygfabuilding_s	largestpropertyusetypegfa	energystarscore	totalghgemissions	zipcode	latitude	longitude	age	buildingtype	primarypropertytype	neighborhood	steamuse	electricity	naturalgas	defaultdata
councildistrictcode	1.000	-0.038	0.336	0.155	0.154	0.144	0.127	0.075	0.123	-0.195	0.513	-0.348	-0.001	0.149	0.253	0.880	0.214	0.033	0.139	0.098
numberofbuildings	-0.038	1.000	-0.043	0.102	-0.004	0.104	0.118	0.028	0.097	0.038	0.033	0.054	-0.046	0.238	0.153	0.048	0.081	0.000	0.000	0.000
numberoffloors	0.336	-0.043	1.000	0.443	0.262	0.435	0.416	0.127	0.171	-0.229	0.066	-0.114	-0.294	0.245	0.263	0.137	0.262	0.000	0.046	0.000
propertygfatotal	0.155	0.102	0.443	1.000	0.347	0.983	0.930	0.083	0.584	-0.091	-0.057	-0.022	-0.313	0.144	0.175	0.057	0.149	0.000	0.027	0.000
propertygfaparking	0.154	-0.004	0.262	0.347	1.000	0.223	0.274	0.014	0.207	-0.124	0.015	-0.053	-0.240	0.052	0.156	0.061	0.084	0.000	0.015	0.000
propertygfabuilding_s	0.144	0.104	0.435	0.983	0.223	1.000	0.928	0.083	0.579	-0.079	-0.066	-0.017	-0.285	0.165	0.191	0.046	0.125	0.000	0.025	0.000
largestpropertyusetypegfa	0.127	0.118	0.416	0.930	0.274	0.928	1.000	0.093	0.570	-0.053	-0.049	-0.013	-0.291	0.148	0.230	0.045	0.147	0.000	0.025	0.000
energystarscore	0.075	0.028	0.127	0.083	0.014	0.083	0.093	1.000	-0.100	-0.003	0.085	-0.037	-0.080	0.119	0.121	0.057	0.000	1.000	0.103	0.110
totalghgemissions	0.123	0.097	0.171	0.584	0.207	0.579	0.570	-0.100	1.000	-0.129	-0.110	0.026	-0.025	0.126	0.259	0.000	0.198	0.000	0.034	0.000
zipcode	-0.195	0.038	-0.229	-0.091	-0.124	-0.079	-0.053	-0.003	-0.129	1.000	-0.048	0.008	-0.088	0.053	0.076	0.255	0.150	0.030	0.088	0.064
latitude	0.513	0.033	0.066	-0.057	0.015	-0.066	-0.049	0.085	-0.110	-0.048	1.000	-0.027	-0.133	0.151	0.215	0.588	0.302	0.036	0.152	0.142
longitude	-0.348	0.054	-0.114	-0.022	-0.053	-0.017	-0.013	-0.037	0.026	0.008	-0.027	1.000	0.049	0.127	0.148	0.490	0.167	0.063	0.063	0.199
age	-0.001	-0.046	-0.294	-0.313	-0.240	-0.285	-0.291	-0.080	-0.025	-0.088	-0.133	0.049	1.000	0.160	0.187	0.176	0.155	0.039	0.342	0.046
buildingtype	0.149	0.238	0.245	0.144	0.052	0.165	0.148	0.119	0.126	0.053	0.151	0.127	0.160	1.000	0.732	0.200	0.195	0.175	0.283	0.708
primarypropertytype	0.253	0.153	0.263	0.175	0.156	0.191	0.230	0.121	0.259	0.076	0.215	0.148	0.187	0.732	1.000	0.244	0.295	0.179	0.349	0.606
neighborhood	0.880	0.048	0.137	0.057	0.061	0.046	0.045	0.057	0.000	0.255	0.588	0.490	0.176	0.200	0.244	1.000	0.288	0.057	0.158	0.149
steamuse	0.214	0.081	0.262	0.149	0.084	0.125	0.147	0.000	0.198	0.150	0.302	0.167	0.155	0.195	0.295	0.288	1.000	0.000	0.013	0.017
electricity	0.033	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000	0.030	0.036	0.063	0.039	0.175	0.179	0.057	0.000	1.000	0.013	0.000
naturalgas	0.139	0.000	0.046	0.027	0.015	0.025	0.025	0.103	0.034	0.088	0.152	0.063	0.342	0.283	0.349	0.158	0.013	0.013	1.000	0.035
defaultdata	0.098	0.000	0.000	0.000	0.000	0.000	0.000	0.110	0.000	0.064	0.142	0.199	0.046	0.708	0.606	0.149	0.017	0.000	0.035	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	buildingtype	primarypropertytype	taxparcelidentificationnumber	councildistrictcode	neighborhood	numberofbuildings	numberoffloors	propertygfatotal	propertygfaparking	propertygfabuilding_s	listofallpropertyusetypes	largestpropertyusetype	largestpropertyusetypegfa	energystarscore	steamuse	electricity	naturalgas	defaultdata	compliancestatus	totalghgemissions	zipcode	latitude	longitude	age
0	NonResidential	Hotel	0659000030	7	DOWNTOWN	1	12	88434	0	88434	Hotel	Hotel	88434.0	60.0	True	True	True	False	Compliant	249.98	98101.0	47.61220	-122.33799	96
1	NonResidential	Hotel	0659000220	7	DOWNTOWN	1	11	103566	15064	88502	Hotel, Parking, Restaurant	Hotel	83880.0	61.0	False	True	True	False	Compliant	295.86	98101.0	47.61317	-122.33393	27
2	NonResidential	Hotel	0659000475	7	DOWNTOWN	1	41	956110	196718	759392	Hotel	Hotel	756493.0	43.0	True	True	True	False	Compliant	2089.28	98101.0	47.61393	-122.33810	54
3	NonResidential	Hotel	0659000640	7	DOWNTOWN	1	10	61320	0	61320	Hotel	Hotel	61320.0	56.0	True	True	True	False	Compliant	286.43	98101.0	47.61412	-122.33664	97
4	NonResidential	Hotel	0659000970	7	DOWNTOWN	1	18	175580	62000	113580	Hotel, Parking, Swimming Pool	Hotel	123445.0	75.0	False	True	True	False	Compliant	505.01	98121.0	47.61375	-122.34047	43
5	Nonresidential COS	Other	0660000560	7	DOWNTOWN	1	2	97288	37198	60090	Police Station	Police Station	88830.0	NaN	False	True	True	False	Compliant	301.81	98101.0	47.61623	-122.33657	24
6	NonResidential	Hotel	0660000825	7	DOWNTOWN	1	11	83008	0	83008	Hotel	Hotel	81352.0	27.0	False	True	True	False	Compliant	176.14	98101.0	47.61390	-122.33283	97
7	NonResidential	Other	0660000955	7	DOWNTOWN	1	8	102761	0	102761	Other - Entertainment/Public Assembly	Other - Entertainment/Public Assembly	102761.0	NaN	True	True	True	False	Compliant	221.51	98101.0	47.61327	-122.33136	97
8	NonResidential	Hotel	0939000080	7	DOWNTOWN	1	15	163984	0	163984	Hotel	Hotel	163984.0	43.0	False	True	True	False	Compliant	392.16	98104.0	47.60294	-122.33263	119
9	Multifamily MR (5-9)	Mid-Rise Multifamily	0939000105	7	DOWNTOWN	1	6	63712	1496	62216	Multifamily Housing	Multifamily Housing	56132.0	1.0	True	True	True	False	Compliant	151.12	98104.0	47.60284	-122.33184	113

	buildingtype	primarypropertytype	taxparcelidentificationnumber	councildistrictcode	neighborhood	numberofbuildings	numberoffloors	propertygfatotal	propertygfabuilding_s	listofallpropertyusetypes	largestpropertyusetype	largestpropertyusetypegfa	energystarscore	steamuse	electricity	naturalgas	defaultdata	compliancestatus	totalghgemissions	zipcode	latitude	longitude	age
3315	Nonresidential COS	Office	2425039137	7	MAGNOLIA / QUEEN ANNE	1	1	13661	13661	Office	Office	13661.0	75.0	False	True	False	True	NaN	3.50	98119.2	47.63572	-122.37525	71
3316	Nonresidential COS	Other	2925049087	3	EAST	1	1	23445	23445	Other - Recreation	Other - Recreation	23445.0	NaN	False	True	True	False	Compliant	259.22	98106.0	47.63228	-122.31574	111
3317	Nonresidential COS	Mixed Use Property	7544800245	3	CENTRAL	1	1	20050	20050	Fitness Center/Health Club/Gym, Office, Other - Recreation, Other - Technology/Science	Other - Recreation	8108.0	NaN	False	True	True	False	Compliant	60.81	98126.4	47.60775	-122.30225	29
3318	Nonresidential COS	Office	4154300585	2	SOUTHEAST	1	1	15398	15398	Office	Office	15398.0	93.0	False	True	True	True	NaN	7.79	98120.6	47.56440	-122.27813	63
3319	Nonresidential COS	Other	2524039059	1	DELRIDGE	1	1	18261	18261	Other - Recreation	Other - Recreation	18261.0	NaN	False	True	True	False	Compliant	20.33	98126.0	47.54067	-122.37441	41
3320	Nonresidential COS	Office	1624049080	2	GREATER DUWAMISH	1	1	12294	12294	Office	Office	12294.0	46.0	False	True	True	True	NaN	20.94	98126.0	47.56722	-122.31154	33
3321	Nonresidential COS	Other	3558300000	2	DOWNTOWN	1	1	16000	16000	Other - Recreation	Other - Recreation	16000.0	NaN	False	True	True	False	Compliant	32.17	98116.0	47.59625	-122.32283	19
3322	Nonresidential COS	Other	1794501150	7	MAGNOLIA / QUEEN ANNE	1	1	13157	13157	Fitness Center/Health Club/Gym, Other - Recreation, Swimming Pool	Other - Recreation	7583.0	NaN	False	True	True	False	Compliant	223.54	98112.0	47.63644	-122.35784	49
3323	Nonresidential COS	Mixed Use Property	7883603155	1	GREATER DUWAMISH	1	1	14101	14101	Fitness Center/Health Club/Gym, Food Service, Office, Other - Recreation, Pre-school/Daycare	Other - Recreation	6601.0	NaN	False	True	True	False	Compliant	22.11	98108.0	47.52832	-122.32431	34
3324	Nonresidential COS	Mixed Use Property	7857002030	2	GREATER DUWAMISH	1	1	18258	18258	Fitness Center/Health Club/Gym, Food Service, Office, Other - Recreation, Pre-school/Daycare	Other - Recreation	8271.0	NaN	False	True	True	False	Compliant	41.27	98118.7	47.53939	-122.29536	85

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Math Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Dash Punctuation

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Decimal Number

Space Separator

Dash Punctuation

Open Punctuation